How to prevent database corruption?

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject:

There are several possible causes of database corruption. You may be able to correct corruption if the database is not badly corrupted. Keeping the database clean and up to date may reduce the probability that it will become corrupt.

Here are the possible causes of corruption, and how to try to fix corruption if it happens:

Database corruption may occur due to internal issues (software problems in the Notes Domino Server code or the
Notes Client code) or external issues which effect expected Notes Domino operation.

Improper operation procedures (such as improper shutdown of the application)
Third party software applications - backup, and antivirus applications write to the file
Operating system or network problems
Hardware failures - especially harddrive crashes

Steps you can take to try to fix database corruption :

If you have been using a custom mail template
replace design twice - first with the discussion database template then the standard Lotus mail template from the server.
Open the database in the Designer client and manually remove any design elements that prohibit design refresh set.

1. Create a new local replica of the database - onto another server/workstation - File / Replication / New Replica.
2. Create a new copy of the database - File / Database / New Copy.
3. On Domino server console run these utilities :
Load FIXUP mail/database.NSF -F -J : F all docs, use J if you are using transactional logging.
Load UPDALL mail/database.nsf -RX : R rebuild indecies
Load COMPACT mail/database.nsf -c -d -i : c copy-style, i ignore errors, will not run if the database is open (in use).
4. Restore from backup
5. Create a new empty database using the same database template and copy the documents over.

Title:    How to copy all documents and folders from one mail database to another using LotusScript
Doc #:    1110903
URL:    http://www.ibm.com/support/docview.wss?rs=899&uid=swg21110903

Title: How to use the Administrative Tools
Doc #: 1459332
URL: http://www.ibm.com/support/docview.wss?uid=swg21459332

Title: NotesPeek 1.53 tool for viewing Notes databases on Notes 6.x and higher
Doc #: 4005686
URL: http://www.ibm.com/support/docview.wss?uid=swg24005686

Doc :7003329 Diagnostic Tool: Mail Database Analyzer (MDA) for Windows NT and AIX User Manual
    The Mail Database Analyzer (MDA) tool is software which performs analysis of Notes mail databases.

Process Monitor is an advanced monitoring tool for Windows that shows real-time file system, Registry and process/thread activity.

http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

Feedback response number WEBB8FVLDV created by ~Maria Nonwelitflar on 04/13/2011